CREATE OR REPLACE TRIGGER ARMY_ID_SEQ_TRIGGER
BEFORE INSERT ON ARMY
FOR EACH ROW WHEN (NEW.ARMY_ID IS NULL)
BEGIN 
	SELECT ARMY_ID_SEQ.NEXTVAL 
	INTO :NEW.ARMY_ID 
	FROM DUAL;
END;